package cn.com.api.mapper.base;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import com.sdicons.json.validator.impl.predicates.True;

import cn.com.api.entity.ApiD_invite_record;

//DAO
public interface D_invite_recordMapperBase {

	// 根据id查看
	@Select("SELECT * FROM d_invite_record  WHERE RECORDID = #{recordid}")
	public ApiD_invite_record findD_invite_recordById(Integer recordid);

	// 查看数据集
	@Select("SELECT * FROM D_invite_record")
	public List<ApiD_invite_record> findD_invite_records();

	// 添加
	@Insert("INSERT INTO d_invite_record (INVITERId, INVITEEID, CREATE_TIME, TYPE) VALUES (#{inviterid}, #{inviteeid}, #{create_time}, #{type})")
	@Options(useGeneratedKeys = true, keyProperty = "recordid")
	public int insertD_invite_record(ApiD_invite_record d_invite_record);

	// 修改
	@Update("UPDATE d_invite_record SET INVITERId = #{inviterid}, INVITEEID = #{inviteeid}, CREATE_TIME = #{create_time}, TYPE = #{type} WHERE RECORDID = #{recordid}")
	public int updateD_invite_record(ApiD_invite_record d_invite_record);

	// 删除
	@Delete("DELETE FROM d_invite_record  WHERE RECORDID = #{recordid}")
	public int deleteD_invite_record(Integer recordid);

	// Foreign keys revelant

	// region Indexs revelant

}
